package com.ktjiaoyu.crm.repository;
import com.ktjiaoyu.crm.pojo.User;
import org.springframework.data.jpa.repository.JpaRepository;
public interface UserRepository extends JpaRepository<User,Long>{

//    List<User> findByUsrNameLike(String usrName);
//
//    @Query(value = "select u from User u where u.usrRoleId=:roleId")
//    List<User> findByRoleId(@Param("roleId") Long roleId);
//
//    @Transactional(timeout = 10)
//    @Modifying
//    @Query("update  User u set u.usrName=?1 where u.usrId=?2")
//    int modifyNameById(String usrName,Long roleId);
//
//    List<User> findUsersByName(String usrName);
//
//    @Query("select u from User u where u.usrRoleId=?1")
//    Page<User> findPageByUsrRoleId(Long roleId, Pageable pageable);
}
